﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Huanbeng.aspx.cs" Inherits="Huanbeng_Huanbeng" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style2
        {
            font-size: medium;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <strong><span class="style2">换泵部分<br />
    </span>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
        AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:CommandField ShowEditButton="True" />
            <asp:BoundField DataField="JH" HeaderText="井号" SortExpression="JH" />
            <asp:BoundField DataField="DH" HeaderText="队号" SortExpression="DH" />
            <asp:BoundField DataField="SBRQ" DataFormatString="{0:d}" HeaderText="上报日期" 
                SortExpression="SBRQ" />
            <asp:BoundField DataField="KGRQ" DataFormatString="{0:d}" HeaderText="开工日期" 
                SortExpression="KGRQ" />
            <asp:BoundField DataField="WGRQ" DataFormatString="{0:d}" HeaderText="完工日期" 
                SortExpression="WGRQ" />
            <asp:BoundField DataField="SGFS" HeaderText="施工方式" SortExpression="SGFS" />
            <asp:BoundField DataField="HQBJ" HeaderText="换前泵径" SortExpression="HQBJ" />
            <asp:BoundField DataField="HHBJ" HeaderText="换后泵径" SortExpression="HHBJ" />
            <asp:BoundField DataField="BZ" HeaderText="备注" SortExpression="BZ" />
        </Columns>
    </asp:GridView>
    </strong><br />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionStringForOracle %>" 
        DeleteCommand="DELETE FROM &quot;BC_HUANBENG&quot; WHERE &quot;JH&quot; = :JH AND &quot;SBRQ&quot; = :SBRQ" 
        InsertCommand="INSERT INTO &quot;BC_HUANBENG&quot; (&quot;JH&quot;, &quot;DH&quot;, &quot;SBRQ&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;, &quot;SGFS&quot;, &quot;HQBJ&quot;, &quot;HHBJ&quot;) VALUES (:JH, :DH, :SBRQ, :KGRQ, :WGRQ, :SGFS, :HQBJ, :HHBJ)" 
        ProviderName="<%$ ConnectionStrings:ConnectionStringForOracle.ProviderName %>" 
        SelectCommand="SELECT &quot;JH&quot;, &quot;DH&quot;, &quot;SBRQ&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;, &quot;SGFS&quot;, &quot;HQBJ&quot;, &quot;HHBJ&quot;,&quot;BZ&quot; FROM &quot;BC_HUANBENG&quot; WHERE (&quot;KGRQ&quot; IS NULL OR &quot;WGRQ&quot; IS NULL OR &quot;HQBJ&quot; IS NULL OR &quot;HHBJ&quot; IS NULL)" 
        UpdateCommand="UPDATE &quot;BC_HUANBENG&quot; SET &quot;DH&quot; = :DH, &quot;KGRQ&quot; = :KGRQ, &quot;WGRQ&quot; = :WGRQ, &quot;SGFS&quot; = :SGFS, &quot;HQBJ&quot; = :HQBJ, &quot;HHBJ&quot; = :HHBJ,&quot;BZ&quot;=:BZ  WHERE &quot;JH&quot; = :JH AND &quot;SBRQ&quot; = :SBRQ">
        <DeleteParameters>
            <asp:Parameter Name="JH" Type="String" />
            <asp:Parameter Name="SBRQ" Type="DateTime" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="JH" Type="String" />
            <asp:Parameter Name="DH" Type="String" />
            <asp:Parameter Name="SBRQ" Type="DateTime" />
            <asp:Parameter Name="KGRQ" Type="DateTime" />
            <asp:Parameter Name="WGRQ" Type="DateTime" />
            <asp:Parameter Name="SGFS" Type="String" />
            <asp:Parameter Name="HQBJ" Type="Decimal" />
            <asp:Parameter Name="HHBJ" Type="Decimal" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="DH" Type="String" />
            <asp:Parameter Name="KGRQ" Type="DateTime" />
            <asp:Parameter Name="WGRQ" Type="DateTime" />
            <asp:Parameter Name="SGFS" Type="String" />
            <asp:Parameter Name="HQBJ" Type="Decimal" />
            <asp:Parameter Name="HHBJ" Type="Decimal" />
            <asp:Parameter Name="BZ" />
            <asp:Parameter Name="JH" Type="String" />
            <asp:Parameter Name="SBRQ" Type="DateTime" />
        </UpdateParameters>
    </asp:SqlDataSource>
</asp:Content>

